Table 20–1: PROUTIL utility qualifiers
|
Qualifier
|
Description
|
|
2PHASE BEGIN
|
Enables two-phase commit.
|
|
2PHASE COMMIT
|
Determines whether the coordinator database committed a transaction.
|
|
2PHASE END
|
Disables two-phase commit.
|
|
2PHASE MODIFY
|
Changes the nickname or priority of a database for two-phase commit.
|
|
2PHASE RECOVER
|
Commits or aborts limbo transactions for a database.
|
|
BIGROW
|
Specifies the number of BI clusters available to a database.
|
|
BULKLOAD
|
Loads data files into a database.
|
|
BUSY
|
Determines whether the database is currently in use.
|
|
CHANALYS
|
Displays information about free chain blocks.
|
|
CODEPAGE- COMPILER
|
Compiles a conversion map file from text format to binary format.
|
|
CONV910
|
Converts a Progress Version 9 database to an OpenEdge Release 10 database.
|
|
CONVCHAR
|
Converts a database’s character set or identifies a database’s character set (for undefined databases).
|
|
CONVFILE
|
Converts a text file from one character set to any other character set.
|
|
DISPTOSSCREATLIMITS
|
Display the block toss and create limits for all tables and BLOBS in a specified area.
|
|
DBANALYS
|
Displays statistical information about index, record, and free chain blocks.
|
|
DBAUTHKEY
|
Sets an authorization key for a database.
|
|
DBIPCS
|
Displays status information for shared-memory segments attached by all OpenEdge databases on the system.
|
|
DISABLEAUDITING
|
Disables auditing for a database.
|
|
DISABLEJTA
|
Disables database participation in distributed JTA transactions.
|
|
DUMP
|
Performs a binary dump, which is generally faster that an ASCII dump.
|
|
DUMPSPECIFIED
|
Performs a selective binary dump and allows you to dump by field value.
|
|
ENABLEAUDITING
|
Enables auditing for a database.
|
|
ENABLELARGEFILES
|
Enables large file processing for a database.
|
|
ENABLEPDR
|
Enables database replication with Peer Direct.
|
|
ENABLEJTA
|
Enables the database to participate in distributed JTA transactions.
|
|
HOLDER
|
Determines whether the database is currently in use in single-user mode, multi-user mode, or by a utility.
|
|
IXDACTIVATE
|
Activates an inactive index.
|
|
IDXANALYS
|
Displays information on index blocks.
|
|
IDXCOMPACT
|
Performs index compaction online and increases space utilization of the index block to a specified compacting percentage.
|
|
IDXMOVE
|
Moves an index from one application data area to another while the database remains online.
|
|
IDXBUILD
|
Consolidates index records to use disk space as efficiently as possible. Activates deactivated indexes in the database. Repairs corrupted indexes in the database.
|
|
IDXCHECK
|
Checks database indexes to determine whether an index is corrupt, and if it is, diagnoses the problem.
|
|
IDXFIX
|
Checks database records and indexes to determine whether an index is corrupt or a record has a missing or incorrect index. You can scan the database, the indexes, or both. IDXFIX will also repair corrupted indexes.
|
|
IOSTATS
|
Provides current statistics for active databases. The statistics include buffered, unbuffered, and logical I/O database operations. The statistics are cumulative from database startup.
|
|
LOAD
|
Performs a binary load.
|
|
MVSCH
|
Moves schema after a database conversion.
|
|
RCODEKEY
|
Inserts the authorization key into existing CRC-based r-code.
|
|
SETAREACREATELIMIT
|
Set the create limit for the specified area.
|
|
SETAREATOSSLIMIT
|
Set the toss limit for the specified area.
|
|
SETBLOBCREATELIMIT
|
Set the create limit for the specified BLOB object.
|
|
SETBLOBTOSSLIMIT
|
Set the toss limit for the specified BLOB object.
|
|
SETTABLECREATELIMIT
|
Set the create limit for the specified table.
|
|
SETTABLETOSSLIMIT
|
Set the toss limit for the specified table.
|
|
TABANALYS
|
Displays information about the degree of fragmentation for each table in a database.
|
|
TABLEMOVE
|
Moves a table and optionally its associated indexes from one storage area to another while the database remains online.
|
|
TRUNCATE AREA
|
Truncates application data storage areas in the specified database. Use this qualifier before you remove storage areas and extents.
|
|
TRUNCATE BI
|
Performs three functions: Uses the information in the before-image (BI) files to bring the database up to date, waits to verify that the information has been successfully written to the disk, then truncates the before-image file to its original length. Sets the BI cluster size using the Before-image Filename (-bi) parameter. Sets the BI block size using the Before-image Block Size (-biblocksize) parameter.
|
|
UPDATESCHEMA
|
Loads the specified database with the most recent meta-schema.
|
|
UPDATEVST
|
Loads the specified database with the most recent virtual system tables.
|
|
WBREAK- COMPILER
|
Compiles the word-break table.
|
|
WORD-RULES
|
Compiles a word-rules file.
|